/*
 Navicat Premium Data Transfer

 Source Server         : Sakura
 Source Server Type    : MySQL
 Source Server Version : 80015
 Source Host           : localhost:3306
 Source Schema         : yunshop

 Target Server Type    : MySQL
 Target Server Version : 80015
 File Encoding         : 65001

 Date: 05/01/2020 17:03:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_category
-- ----------------------------
DROP TABLE IF EXISTS `t_category`;
CREATE TABLE `t_category` (
  `cid` varchar(100) NOT NULL,
  `cname` varchar(255) DEFAULT NULL,
  `cdesc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_category
-- ----------------------------
BEGIN;
INSERT INTO `t_category` VALUES ('1', '电脑办公', '1');
INSERT INTO `t_category` VALUES ('2', '数码相机', '2');
INSERT INTO `t_category` VALUES ('3', '手机通讯', '3');
INSERT INTO `t_category` VALUES ('4', '服装装饰', '4');
INSERT INTO `t_category` VALUES ('5', '化妆保养', '5');
INSERT INTO `t_category` VALUES ('6', '蔬菜水果', '6');
INSERT INTO `t_category` VALUES ('7', '海鲜肉类', '7');
INSERT INTO `t_category` VALUES ('8', '儿童玩具', '8');
COMMIT;

-- ----------------------------
-- Table structure for t_manage
-- ----------------------------
DROP TABLE IF EXISTS `t_manage`;
CREATE TABLE `t_manage` (
  `mid` int(10) NOT NULL,
  `mname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `mpassword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`mid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_manage
-- ----------------------------
BEGIN;
INSERT INTO `t_manage` VALUES (1, 'admin', '123');
COMMIT;

-- ----------------------------
-- Table structure for t_orderitem
-- ----------------------------
DROP TABLE IF EXISTS `t_orderitem`;
CREATE TABLE `t_orderitem` (
  `itemid` varchar(100) NOT NULL,
  `count` int(50) DEFAULT NULL,
  `subtotal` varchar(100) DEFAULT NULL,
  `pid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `oid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for t_orders
-- ----------------------------
DROP TABLE IF EXISTS `t_orders`;
CREATE TABLE `t_orders` (
  `oid` varchar(100) NOT NULL,
  `oordertime` varchar(100) DEFAULT NULL,
  `ostate` int(50) DEFAULT NULL,
  `ototal` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `oaddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `oname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `otelephone` int(50) DEFAULT NULL,
  `uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for t_product
-- ----------------------------
DROP TABLE IF EXISTS `t_product`;
CREATE TABLE `t_product` (
  `pid` varchar(100) NOT NULL,
  `pname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `pmarket_price` varchar(255) DEFAULT NULL,
  `pshop_price` varchar(255) DEFAULT NULL,
  `pimage` varchar(255) DEFAULT NULL,
  `pdate` varchar(255) DEFAULT NULL,
  `pis_hot` int(50) DEFAULT NULL,
  `pdesc` varchar(255) DEFAULT NULL,
  `pflag` int(50) DEFAULT NULL,
  `cid` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_product
-- ----------------------------
BEGIN;
INSERT INTO `t_product` VALUES ('1', '联想ThinkPad', '12000', '9000', '/image/shangpinxiangqing/1.1.jpg', '20190101', 0, 'ThinkPad 2019', 1, '1');
INSERT INTO `t_product` VALUES ('2', '数码相机', '8000', '6000', '/image/shangpinxiangqing/2.1.jpg', '20190202', 0, 'Lumix 数码相机', 2, '2');
INSERT INTO `t_product` VALUES ('3', '华为智能手机', '10000', '8000', '/image/shangpinxiangqing/3.1.jpg', '20190303', 0, '华为P30 Pro', 3, '3');
INSERT INTO `t_product` VALUES ('4', '连衣裙', '200', '100', '/image/shangpinxiangqing/4.1.jpg', '20190404', 0, '衣香丽影 爆款连衣裙', 4, '4');
INSERT INTO `t_product` VALUES ('5', '补水面膜', '800', '500', '/image/shangpinxiangqing/5.1.jpg', '20190505', 0, '芦荟补水面膜', 5, '5');
INSERT INTO `t_product` VALUES ('6', '红富士', '12', '6', '/image/shangpinxiangqing/6.1.jpg', '20190606', 0, '红富士苹果', 6, '6');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `uid` varchar(100) NOT NULL,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `upassword` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `uname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `uemail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `utelephone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `ubirthday` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `usex` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `ustate` int(50) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1', 'user', '123', '李成驹', '1@qq.com', '111', '19990101', '男', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
